#!/usr/bin/expect

spawn build/bin/observer -f etc/observer.ini -P cli 
expect "miniob >"
send "drop table t\r"
expect "miniob >"
send "create table t(id int nullable, name char(20) nullable);\r"
expect "miniob >"
send "insert into t values(1, '2020vsaf-01-01');\r"
expect "miniob >"
send "insert into t values(null, null);\r"
expect "miniob >"
send "insert into t values(1, 'svac0-02v');\r"
expect "miniob >"
send " update t set name=NULL where id=1;\r"
expect "miniob >"
send "select * from t where 'a' is null;\r"
expect "miniob >"
send "select * from t where null is 'a';\r"
expect "miniob >"
send "select * from t;\r"
interact